Msg001 This is the 'Display Bills' (AP) general module window. AP stands for Accounts Payable - your monthly obligations. The first controls to be explained are some of the command bar buttons. These buttons are arranged across the top of the module window under the two rows of identifying labels. Notice that they are arranged into four groups. i.e. 'Module Mode'; 'Browse Buttons'; 'Related Modules' and 'Action Buttons.'
Msg002 The first of this series of lessons will demonstrate a 'Module Mode' command bar button. Place your cursor over the command bar button towards the left that is labeled 'Edit' and click the left mouse button. Notice that the caption in the 'View Mode' information box towards the lower right corner of the module window changes to 'Edit.'
Msg003 The Bills module is now in Edit mode. To edit a record you must select a record to edit from the list box. The list box is the large area that contains a summary of all the AP accounts set up in this module. This yellow tutorial box is just above it. Click on any record in the list box and see all the account information pasted into the text boxes below.
Msg004 Now that an account is displayed in the text boxes you may click on any of the text boxes that you wish to edit. Correct the information in any or all text boxes necessary. EXAMPLE: Change the 'Payment' amount to 200 dollars for the selected record. Click on the 'Action Button' labeled 'Save' towards the right end of the command bar.
Msg005 To create a new record you should click on the 'New' module mode command bar button. Notice that the text boxes will clear if there is data in them and view mode changes to 'Create.' The cursor should then be blinking in the first text box labeled 'Account Name.'
Msg006 EXAMPLE: Enter any name for the new account. You will be asked later if this account will pay to a savings account. If it will - you MUST name this account identically to the savings account. After the account name is entered press the 'Tab' keyboard key to move the focus to the next text box labeled 'Account Number.' Enter any account number. Continue in this fashion until all the text boxes are filled in. You may skip text boxes if they do not apply to the account you are creating. Notice that occasionally a dialog box will appear.
Msg007 The dialog boxes are used for account setup and configuration. They take only YES or NO answers selected from command buttons. To see the first dialog box (if you haven't already) click the 'Payment Method' text box. If the account is serviced by a bank service plan answer YES - otherwise answer NO. If you selected NO then an auxiliary dialog appears. You should select YES if you pay bills with cash. If you answer NO then CEW assumes you use checks to pay your bills.
Msg008 After the Payment Method is determined another question appears. It should be answered like the first (and second) - YES or NO. Continue tabbing to text boxes until all the text boxes are dealt with. When you get to the 'Classification' text box try to create a class specific to the kind of account you are creating. If the class has already been created you may select the class from the list that pops up when this text box is selected. To learn more about classifications see the 'User Guide' or the on-line 'Help.'
Msg009 When the account has been created you must click on the 'Save' action button to write the new record to the AP file. When the account is written to the AP file it is also written to a 'Tracker' file. The tracker file maintains records of all transactions performed on each account.
Msg010 More about tracker files later. You should create an account in the 'Bills' (AP) module for every obligation that you have. You can create accounts for all your bills as well as for savings accounts that receive regular deposits. You can setup the account to utilize bank service plans or to be paid by cash or checks - and the account may have a fixed or fluctuating payment.
Msg011 To delete an account that is no longer needed you should select the 'Delete' 'Module Mode' command bar button. Select the account to delete from the list box then click the 'Delete' 'Action Button' command bar button. The account will be erased from the files. Of course to just view records you may select the 'View' command bar button and browse your records with impunity. Records are not alterable in view mode. When you select 'View' notice that both the 'Delete' and the 'Save' command bar buttons disappear.
Msg012 The next series of topics are about support modules. There are several routines that let us view different aspects of the Bills (AP) records and accounts. The first I will discuss is 'Purchase.' This module allows you to enter your credit purchases into the accounts of the Bills module. Select the Related Modules' command bar button labeled 'Pur' - it looks like a Visa credit card.
Msg013 If you entered a purchase then saved it - the 'Display Bills' module will automatically update when you return to it. The second support module I will discuss is the 'Tracker' module. Select the command bar button labeled 'Track.' It is the button with footprints on it.
Msg014 The next AP support module is the graphing utility. Select 'Graph' from the command bar. It is the button that has the pie chart and bar chart drawn on it.
Msg015 The fourth AP support module is 'Loan Sheet.' Select the command bar button with the little blue grid on it that is labeled 'LS.'
Msg016 The last AP support module is 'Loan Amortization.' Click the command bar button labeled 'Amort' to start this module. This command bar button has a bar chart on it.
Msg017 The other un-discussed command bar button is 'Clear.' If information is displaced in the text boxes and you wish to remove all data from the text boxes - click the Clear command bar button. The Calculator button is visible in this command bar also. It was discussed earlier. You should try out the calculator some time during the tutorial so you can get the 'feel' of it.
Msg018 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you should then click the 'Exit' command button to return to the tutorial.
Msg019
Msg020 This is the 'Display Checking' general module window. The first controls to be explained are some of the command bar buttons. These buttons are arranged across the top of the module window under the two rows of identifying labels. Notice that they are arranged into four groups. i.e. 'Module Mode'; 'Browse Buttons'; 'Related Modules' and 'Action Buttons.'
Msg021 The first of this series of lessons will demonstrate a 'Module Mode' command bar button. Place your cursor over the command bar button towards the left that is labeled 'Edit' and click the left mouse button. Notice that the caption in the 'View Mode' information box towards the lower right corner of the module window changes to 'Edit.'
Msg022 Now you must select a record in the list box that you wish to edit. The list box is the large area that contains a summary of all the checking transactions you have entered. This yellow tutorial box is just above it. Click on any transaction in the list box and see all the information about the transaction pasted into the text boxes below.
Msg023 Now that the transaction is displayed in the text boxes you may click on any of the text boxes that you wish to edit. Correct the information in any or all text boxes necessary. EXAMPLE: Change the 'Amount' to a different value for the selected transaction. Click on the 'Action Button' labeled 'Save' towards the right end of the command bar. A dialog box may appear. That tells you that the class assigned to this account doesn't need to be created - it exists already. If you created a new class for the account the dialog will tell you a new class was created.
Msg024 To create a new record you must go to one of the transaction modules ('Deposit'; 'Transaction' or 'Pay Bills') discussed later. To Delete a checking record or to Void a checking record you must select the 'Module Mode' command bar button for the function you wish to perform. Next select the record from the list box (like you did in Edit). Finally select the 'Action Button' for the desired function. You may 'UN'-void a record but deleting is permanent - be careful.
Msg025 Checking has several support modules. These routines let you do checking account related functions. The first I will discuss is graph. Click on the command bar button labeled 'Graphs.' When the module starts you will see a pie chart of all the checking records with check amounts that are found (if any) in the Checking module.
Msg026 Graphing your checking records is useful to see visually the categories (classifications) that your checks are written to. Graphing may be used with the check register and for searches if you are searching ALL checks. To Search for all checks you should leave the 'Search Data' text box empty in the search module. More about check searching later.
Msg027 There are a few graphing options available when the window opens up. You may graph check amounts or percentages or you may view a pie or bar chart. You may copy the graph to the Windows clipboard or print it to your printer. Experiment with these options by clicking some the option buttons in the lower left of this module.
Msg028 'Play' with these functions as you wish or until you become familiar with this routine. Do NOT click the 'Close' command button to make this help window disappear unless you are finished with the checking module tutorial. When you are done experimenting you should click the 'Exit' command button to return to the tutorial.
Msg029 To enter a deposit into your checking account you must open the deposit module. Click on the 'Piggy Bank' command bar button to open it.
Msg030 Notice that the current checking balance is displayed in the 'Current Balance' text box. To enter a deposit you must enter the deposit amount into the 'Deposit Amount' text box then press the Tab key.
Msg031 If you want to enter a short memo to describe the source of the income you may do so in the memo text box. The date is added to your memo.
Msg032 If you are satisfied you may click the 'Save' command button to write the deposit to the checking records. If you are finished then click 'Exit' to leave 'Deposit.'
Msg033 To enter a checking transaction you must use the 'Transaction' module. In order to use this module you must first setup the account as discussed earlier. Click the 'Trans' command bar button to learn about checking transactions. When the window opens select a transaction type from the group of command buttons. Use any transaction type you like for tutorial purposes.
Msg034 An important function of a money manager is using existing records to accomplish tasks. Often you need to search your records for disputed checks. You may want to analyze different aspects of your past spending habits. These things and more may be done with the Search module. Click the command bar button labeled 'Srch' to see how to perform checking account searches.
Msg035 Some time during every month you will get a checking account bank statement from your bank. Reconciliation of the bank statement to your own records no longer needs to be dreaded. To see how easy reconciliation is with CEW click the 'Recon' command bar button.
Msg036 CEW allows automatic bill paying up to nine times per month. The key to this feature is how you set up the account in the 'Bills' modules discussed previously. To see how easy this module is to use - click the Related Modules' 'Bills' command bar button.
Msg037 The records displayed in the checking module may be printed. If you have performed a search (for example) and have records displayed in the list box you may click the 'Print' command bar button to print them. You may print the entire checking register in the same manner.
Msg038 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you should then click the 'Exit' command button to return to the tutorial.
Msg039
Msg040 This is the 'Display Savings' general module window. The first controls to be explained are some of the command bar buttons. Notice that they are arranged into four groups. i.e. 'Module Mode'; 'Browse Buttons'; 'Related Modules' and 'Action Buttons.' These buttons are across the top of the module window under the two rows of labels.
Msg041 The first command bar button to be discussed will be the 'New' button.' Click on this 'Module Mode' command bar button and see both the 'View Mode' and the 'Record Number.' information boxes change to 'Create.' Notice the text boxes clear if there is information in them. The cursor should be in the 'Account Name' text box. Enter any savings account name as you want it to appear in your CEW records and press the tab keyboard key.
Msg042 The cursor should now be in the 'Account Number' text box. Enter any account number if applicable and press tab again. Fill in the text boxes as you tab to them - but only if they apply to the account you are creating. The third text box will display a dialog box that asks a question.
Msg043 Answer the question that appears as it applies to the account. If this is an account that receives regular monthly deposits that you don't personally deposit - answer YES. If it receives irregular deposits made by you then answer NO. If you setup the account to be paid during a 'Pay Bills' session answer NO.
Msg044 Continue tabbing and enter data as it applies to the labels above each text box that you tab to. When you are done entering account information - click the 'Save' command bar 'Action' button to save the account to the proper files.
MSG045 Notice that the new account was added to the list of accounts below - if the account was created properly. The text boxes cleared and the cursor is in the 'Account Name' text box ready for you to start creating another account - but don't enter another one yet..
Msg046 An important option is available when you create a savings account in CEW. If you pay into savings by making a regular cash or check or BSP payment to a savings account every month - you can setup up an account in Bills to handle the transaction automatically for you.
Msg047 If you utilize this option - the savings account NAME and the Bills (AP) account NAME for the savings account MUST BE IDENTICAL. If you intend to setup the account this way answer NO when you are asked if this account will have a payroll deduction type of regular deposit.
Msg048 If you created an account (and subsequently saved it) you may now enter another account or click the 'Next' button in this window to continue. You should NOT click the 'Close' command button unless you are finished with the savings module tutorial.
Msg049 To edit an existing savings account record you should select the 'Edit' 'Module Mode' command bar button. The 'View Mode' information box will change to say 'Edit.'
Msg050 Click on a record from the list box that needs to be corrected. The list box is the large box just under this yellow tutorial window.
Msg051 Now that the record is displayed in the text boxes you should now click in the text box that contains the data that needs to be corrected. EXAMPLE: Click on the 'Account Number' text box.
Msg052 Change the data in this text box or select and modify any other data that you want to change. EXAMPLE: Change the 'Account Number' to something different than it is. When the record is as you want it you may click the 'Save' command bar 'Action' button to write the corrected record to the proper files.
Msg053 You may delete a record by first selecting 'Delete' module mode. Next select the record you want to delete from the list box. Click the 'Delete' command bar 'Action' button to remove the record from the file. Of course to just view records you may select the 'View' command bar button and browse your records with impunity. Records may not be altered in view mode.
Msg054 To start the support module discussion for your savings records start by clicking the Related Modules' command bar button labeled 'Proj.' 'Proj' stands for Projection. This module allows you foresee future values for all your savings accounts as well as for contemplated accounts.
Msg055 The next analysis feature you should try is 'SS.' SS stands for Savings Sheet. Savings sheet is used to enter and manipulate a range of values to see the effects of interest rates and time on a proposed or existing Savings account. Click the Related Modules command bar button labeled 'SS' to experiment with this routine.
Msg056 To enter contributions or withdrawals from a savings account you should click the 'Dep' or 'Draw' command bar buttons. The same module is used for the 'View'; 'Edit'; 'Delete'; 'New'; deposit and withdrawal modes of savings. The only difference is that the cursor locates inside the 'Dep/With Amt' text box. Enter the amount for the transaction into this box. If you need to you may edit any field in the account that is displayed. DO NOT use a minus sign ( - ) when entering withdrawals. CEW will handle that for you.
Msg057 When the amount is entered click the 'Save' command bar button to update the proper records.
Msg058 Last but not least we get to the 'Tracker' Module. When you create a Savings account a tracker record is started for the account. Every time you do a transaction or edit a Savings account the tracker file is updated. Every Savings account has its own tracker file. To use the Tracker module click the 'Track' Related Modules' command bar button.
Msg059 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you should then click the 'Exit' command button to return to the tutorial.
Msg060
Msg061
Msg062
Msg063
Msg064
Msg065
Msg066
Msg067
Msg068
Msg069
Msg070
Msg071
Msg072
Msg073
Msg074
Msg075
Msg076
Msg077
Msg078
Msg079
Msg080 This is Labeler or 'Display Addresses'. From this module you can do many addressing chores. The first controls to be explained are some of the command bar buttons. They are arranged into four groups. i.e. 'Module Mode'; 'Browse Buttons'; 'Related Modules' and 'Action Buttons.' These buttons are across the top of this module window under the two rows of labels.
Msg081 First I'll demonstrate a 'Module Mode' command bar button. Place your cursor over the command bar button towards the left that is labeled 'Edit' and click the left mouse button. Notice that the caption in the 'View Mode' box towards the lower center of the window changes to 'Edit.'
Msg082 To edit a record - select a record in the list box. The list box is the box that contains a summary of all the accounts set up in this module. This tutorial box is just above it. Click on any record in the list box and see all the account information pasted into the text boxes below the list box.
Msg083 Now that the account is displayed in the text boxes you may click on any of the text boxes that you wish to edit and correct the information in any or all text boxes. EXAMPLE: Change the 'First Name' entry for the selected record then click on the 'Action Button' labeled 'Save' towards the right end of the command bar. When you click the 'Save' command bar button the corrections will be written to your hard disk and into the proper file.
Msg084 To create a new address in CEW you should click the 'New' command bar button. Notice that some of the information boxes change to show the new module mode. The cursor should now be in the 'Last Name' text box. Enter the last name into the text box. Tab to the next text box; 'First Name.' Enter the first name and continue tabbing and entering data as it applies to the labels above the text boxes.
Msg085 When the address and telephone numbers are as you want then click the 'Save' command bar button to write the address to the proper file. You may now add more addresses; change the module mode or quit the module. But don't quit yet.
Msg086 The new record will now be displayed in the list box if it was created correctly. If it is not visible then use the scroll bar at the right end of the list box to scroll through the records until you see it. If it was created properly you should be able to find it..
Msg087 As in the other modules you may delete a record by first clicking the 'Delete' 'Module Mode' command bar button; then clicking on the record to delete in the list box; and then clicking the 'Delete' command bar 'Action' button. Viewing is also the same as the other modules. Click the 'View' mode button and browse to your hearts content.
Msg088 The only support module for the Address module is quite a powerful one. Actually it isn't a separate module but an extension of this module. I am talking about the 'Labels' 'Related Modules' command bar button of course. Click this button to see how to use this altered mode of Labeler.
Msg089 The first thing that you might notice is that the text boxes are replaced by a list box. Anther change is the appearance of two groups of option buttons. These new controls will allow you to monitor and control the process of printing addresses.
Msg090 First you must decide what type of addresses to print. If you look in the lower center portion of the window you will see a box labeled 'Address Type.' The choices are 'Personal' and 'Bills.' With option buttons you may only have one option button in a group of option buttons active at any one time. The option buttons determine which type of address to display in the larger list box.
Msg091 The good news is that you may select the 'Personal' address type and select one or more records from that list - then you could select 'Bills' and select one or more address from that list. You may mix the addresses as you see fit before actually printing the addresses. Select the 'Bills' option button by clicking in the circle next to its label.
Msg092 Also present just below the 'Address Type' option box is a text box labeled 'How Many Labels?.' You may change this number for every label or leave it the same for all or some labels. For now enter a 2 in this small text box. When you select addresses from the list that you want to print you will see the name of the addressee placed in the smaller list box. This list box is labeled 'Labels To Print.' This list will help you see which addresses you have already selected.
Msg093 Select a few address from the large list box. Once you have selected all the addresses that you want to print you must decide what the printer medium will be - labels or envelopes. In fact you need to decide on the size of the envelope or the type of label you are going to use. Select the printer medium from the 'Label type' option box. Remember you can only select one.
Msg094 Your choice will depend on the type of printer you have and the type of labels or envelopes you have available. You may change the printer medium now if you wish - or change it any time before you click 'Print.' Print on plain paper for this tutorial if you wish. When all the decisions have been made and all the labels selected - the only thing left to do is print them. Click the 'Print' 'Action' button in the 'Command Bar.'
Msg095 When you select a label or envelope type a dialog will appear with helpful advice on setting the proper form size for the type of printer paper you want to use. Use 'Help' if necessary to set the form size. The Windows print manager dialog will appear and you should set the proper form size according to your needs. If you change label or envelope types you will see this dialog again.
Msg096 You may configure CEW to print reliably on one two or three wide labels - as discussed in the 'Setup' portion of this tutorial. I advise you to run the label setup routine for trouble free label printing. The next topic is only pertinent if you have a modem and told CEW so in the opening setup dialogs.
Msg097 Another button in the 'Action Buttons' section of the command bar is labeled 'Dial.' If Dial is not visible click the 'View' command bar button. Dial is used to - well - dial a phone number. There are a couple of ways to use Dial. Once Labeler is running you may select a name from the list box. You may then double click any displayed telephone number (in a text box - not in the list box) and the number will be dialed on your telephone - IF you have a valid modem setup. If CEW detects an invalid modem setup you will be informed.
Msg098 You will then be presented with a setup window to setup up CEW with valid modem configuration data. Modem setup was covered in the 'setup' portion of this tutorial. You may also click the 'Dial' command bar button to dial the 'Home Telephone' for the record selected. If you do not have a modem connected then the 'Dial' command button will not appear. You have to tell CEW that you have a modem during configuration. You may also run the 'Modem' setup routine found in 'Setup' in the main menu and CEW will figure it out.
Msg099 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you should then click the 'Exit' command button to return to the tutorial.
Msg100 This module is called 'Income and Expense Chart' and is highly subjective to your personal spending habits. The items charted are Checking deposits; Savings deposits; Monthly bills; Income received; and an item called 'Net Cash.' Net Cash is the subjective part of the graph.
Msg101 The Net Cash line on the chart is the difference between 1.) the total monthly bills paid in a month plus reported savings deposits for a month and 2.) your reported income. The chart will show this value as a positive plot (shown as greater than zero) if income is greater than bills plus savings. It will be a negative plot if it isn't.
Msg102 In a nut shell - the plot for Net Cash shows the amount of money left over from your income after Savings and Bills are paid. If you spend this money on food and clothing (for example) and a large sum on non-necessities like entertainment or gifts then this MIGHT represent a bad thing. If and how you spend the money is subjective to your lifestyle. The graph doesn't represent what happens to the money only that it is or isn't there.
Msg103 Of course being subjective in this case means that MAYBE you think that a major portion of your budget may be spent on entertainment and IS essential. I am merely trying to show a perspective of cash spending. The graph merely tries to prompt the user into re-thinking his or her spending habits. If you can see that 40% of your budget is really going to waste on things that really aren't necessary then maybe the graph really isn't all that subjective.
Msg104 Another way to use the graph is to click different items on and off to see how some plots compare to each other - proportionally. The graph will help you see things like the ratio of bills to income or savings to income or Net Cash to Savings deposits. To click the plotted items on or off just click on the small square next to the labels in the 'Data to Graph' box. Clicking will toggle them like the 'Checked' menu items discussed earlier. If the 'X' is in the square then the item will be charted.
Msg105 You may copy the graph to the Windows Clipboard by clicking the 'Copy' command bar button. The copy may then be used in other programs. You may print the graph to your printer by clicking the 'Print' command bar button. If you want to update or view the 'Income Entry' grid (discussed previously) then you may click the 'Inc' command bar button. To see a larger view of the chart just click on it. Click it again to shrink it back to its former size.
Msg106 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you may click the 'Exit' command button to return to the tutorial.
Msg107
Msg108
Msg109
Msg110
Msg111
Msg112
Msg113
Msg114
Msg115
Msg116
Msg117
Msg118
Msg119
Msg120 This is the 'Display Securities' general module window. The first controls I will explain are some of the command bar buttons. Notice that they are arranged into four groups. i.e. 'Module Mode'; 'Browse Buttons'; 'Related Modules' and 'Action Buttons.' These buttons are across the top of the module window under the two rows of labels. For your information; Generally defined - security in this case means any 'share valued' investment.
Msg121 First I'll demonstrate a 'Module Mode' command bar button. The first command bar button to be discussed will be the 'New' button. Click on this 'Module Mode' command bar button and see both the 'View Mode' and the 'Record Number' information boxes change to 'Create.' Notice the text boxes clear if there is information in them. The cursor should be in the 'Account Name' text box. Enter the security account name as you want it to appear in your CEW records. After entering the account name press the tab key.
Msg122 The cursor should now be in the 'Account Number' text box. Enter the account number if it is applicable and press tab again. Continue tabbing and enter data as it applies according to the labels above each text box that you tab to. You can not enter data into the 'Account Value' text box. This entry is calculated from the 'Share Value' and the 'Shares' text boxes.
Msg123 Be sure the account is created properly before you save it. You may NOT edit accounts in the Security module after they are saved. When you are done entering account information click the 'Save' command bar 'Action' button to save the account to the proper files. Clicking 'Save' will cause the account to be created and all the text boxes will clear. You may now enter another account or continue the tutorial by clicking 'Next.' Do NOT click the 'Close' command button unless you are finished with the Securities tutorial.
Msg124 You can now see the new record was added to the list of records in the list box below - if it was created properly. The record may now me utilized like any other Securities record.
Msg125 You may NOT edit a securities account. You may only enter a new 'Share Value' or sell all or part of the shares. To do either you should select the proper 'Module Mode' command bar button. To change share value click on the 'Adjust' 'Module Mode' button. To sell all or part of the shares click on the 'Sell' 'Module Mode' button. Click either the 'Sell' or the 'Adjust' command bar button.
Msg126 Notice that the 'View Mode' information box will change to reflect the new module mode. Click on any record in the list box below to experiment with the 'Adjust' or 'Sell.'
Msg127 When the record is displayed in the text boxes below the list box the 'Shares' or 'Share value' text box will receive the cursor automatically. Correct the data in the text box. EXAMPLE: Change the value in the active text box to something different than it is. Now click the 'Save' command bar 'Action' button to write the corrected record to the proper files.
Msg128 You may delete a record by first selecting 'Delete' mode. Next select the record you want to delete from the list box. Click the 'Delete' command bar 'Action' button to remove the record from the file. Of course to just view records you may select the 'View' command bar button and browse your records with impunity. Records are not alterable in view mode.
Msg129 To start the support module discussion for your securities records start by clicking the Related Modules' command bar button labeled 'Proj.' 'Proj' stands for Projection. This module allows you to foresee future values for all you securities accounts as well and contemplated accounts.
Msg130 The other support feature for 'Securities' is the Tracker Module. When you create a Securities account a tracker record is started for the account. Every time you do a transaction or edit a Securities account the tracker file is updated. Every Securities account has its own tracker file. To use the Tracker module click the 'Track' Related Modules' command bar button.
Msg131 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you should then click the 'Exit' command button to return to the tutorial.
Msg132
Msg133
Msg134
Msg135
Msg136
Msg137
Msg138
Msg139
Msg140 The 'Setup User Data' routine while simple - is very useful and even necessary to the function of CEW. This routine is used to personalize CEW for your use.
Msg141 The information is used to place your name and address on the check facsimiles used in the 'Pay Bills' and 'Transaction' modules. Both of these items are discussed elsewhere.
Msg142 This data is also used for the return address labels on envelopes that you may print. The information will also be placed on the CEW registration form.
Msg143 To enter the data is simple. When the module loads the cursor will locate in the first text box labeled 'Last Name.' Enter your last name then press the tab key.
Msg144 The cursor moves to the next text box labeled 'First Name.' Enter your first name and press the tab key. If you forgot to capitalize the last name that's okay. CEW will capitalize the first letter for you. CEW will do this on most of the proper name text boxes throughout the program.
Msg145 Continue tabbing and entering data as it applies to your own situation. If you are single then skip the spouse entries.
Msg146 If you need to re-enter the information before or after it is saved you may click the 'Clear' command button to start fresh. If you want to edit the information - type over the existing information and then save it.
Msg147 Save the information to disk by clicking on the 'Save' command button. When you click 'Save' the module automatically unloads itself. You may also click the modules' stop light command button to exit this module.
Msg148
Msg149
Msg150
Msg151
Msg152
Msg153
Msg154
Msg155
Msg156
Msg157
Msg158
Msg159
Msg160 When AP Tracker starts you will usually see a graph and two list boxes. If the current account in the AP file has a payment history then a graph of all past payments is presented. The list box at the lower left of the window is a list of all Bills module (AP) accounts. You may select any account from this list to display. Data may not be changed in this routine - data may only be viewed.
Msg161 To see a graph of account balance history for the displayed account you may click the command bar button labeled 'Bal.' If there is no balance history the graph will be blank. You may select 'Pmts'' to show the payment record again if you wish. You may select a related module for the Bills (AP) type of records by clicking one of the 'Related Modules' command bar buttons.
Msg162 While the graphs maybe the most interesting part of this module - there is other information to view also. When the payments and balances are graphed all transactions pertaining to an account are placed into the large list box. You may scroll through the list box to view these transactions and view the check numbers (for checks only) of the payments to the account.
Msg163 You may see every edit you ever made to the account and you may print the contents of the list box and the displayed graph. To print the account information click the 'Print' command bar button.
Msg164 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you may click the 'Exit' command button to return to the tutorial.
Msg165
Msg166
Msg167
Msg168
Msg169
Msg170
Msg171
Msg172
Msg173
Msg174
Msg175
Msg176
Msg177
Msg178
Msg179
Msg180 This module allows you to enter purchases into charge accounts without editing the account. If you make a charge to (for example) your Seers account you may select 'AP Purchase' to do it.
Msg181 When the module loads you should see a list of all Bills (AP) accounts displayed in a list box. To enter the purchase you should select 'Seers Doebuck and Co.' (in this case) from the list. If it is not visible then use the scroll bar on the right edge of the 'AP Accounts' list. The name of the account is placed in the 'Selected Account for Purchase' text box for reference.
Msg182 The cursor then moves to the purchase amount text box. Enter the amount of the purchase and click the 'Save' command button. You may select another account and repeat the last procedure or click the 'traffic light' command button to close the module.
Msg183
Msg184
Msg185
Msg186
Msg187
Msg188
Msg189
Msg190
Msg191
Msg192
Msg193
Msg194
Msg195
Msg196
Msg197
Msg198
Msg199
Msg200 'Checking Transaction (or Write Check) is used to enter any checking transaction into CEW that may occur. If you use printer checks other than to pay your bills you must use this routine for that also. No matter how you pay your bills - with; printer checks; cash; debit card; or hand written checks from your checkbook; you should use the 'Pay Bills' routine discussed elsewhere to do so.
Msg201 If you use a checking account debit card for purchases or if you just want to track expenses paid by cash - then you should use this module for that too. To get to this routine you must select 'Transaction' from the main menu or click on a 'Trans' command bar button found in some of the checking modules. When you click 'Trans' a small auxiliary command bar appears. This command bar has several options on it and you must select the proper option for the transaction you wish to enter into CEW.
Msg202 Obviously if you got this far you selected an option already. No matter what kind of manual checking transaction you want to enter into the CEW check register you must do the same things. All records are entered identically except for the checking number. Only checks (portable or printer) have check numbers. All other transactions have a zero value check number.
Msg203 After you select the transaction type an 'Auto AP' dialog box normally appears. To see the AP list at any time and start a new transaction - just click on the check background then click YES in the dialog box. This box asks if this transaction will pay a bill. You must select YES or NO.
Msg204 If you selected YES (meaning this will be a transaction that pays a bill) then a list box of all the current Bills (AP) accounts is presented on the right end of the window. You must select the account from this list in order for the account to be posted when the transaction is entered.
Msg205 If you change your mind you may click on the check background. This will cause the 'Auto AP' prompt to appear again and you may select NO. If you don't want to write a check after all - then click the stop light command button to exit the Checking Transaction routine.
Msg206 Whether you want to pay a bill or not - how you proceed once you are here depends on how you setup the CEW checking account. In setup you have the option of having CEW keep track of the check numbers on your checks. You may manually enter them every time if you prefer. Assuming you let CEW do the dirty work the cursor will be in the check 'Amount:' text box.
Msg207 If you wish to enter your own check numbers then the cursor will be in the 'No:' text box. If you must enter a check number then do so at this time then press the tab key. The cursor moves to each text box in turn when you press tab.
Msg208 Enter the amount for the check. Press the tab key and see that both the 'Amount' and 'Amt' text boxes are formatted properly. Enter the payee for the check and press tab. Enter a date or press tab if the current date is OK. If you setup the account for on-check addresses fill in the address data. Tab to the 'Memo' text box and enter a memorandum for the check if you want. Press Tab.
Msg209 When you tab to the 'Classification' text box another window opens up. This text box provides an editable list of check classifications that you may select from. As a general note; to learn all about using check classifications I urge you to read the related sections in the User Guide or the on-line help.
Msg210 To select an existing classification just click the mouse on the desired class in the Classification list box. To create a new class just type it into the Classification text box located on the check then click the 'Add' command button. If there is a Classification that you wish to remove from the list you must first click 'Remove Class' then click on the item to remove from the list.
Msg211 After the class information is entered you may then click the signature facsimile to enter the check into the check register. You may also click on the 'Enter' command bar button to do the same. When you click one of these two items several things will happen.
Msg212 First the transaction is entered into the check register. Next if the transaction was for a bill the Bills (AP) records are posted. If the account was setup for a savings account the savings records are posted. Lastly if the check was a printer check it will be printed. If you print laser checks the check won't print until you have entered three records - or you quit the 'Checking Transaction' module.
Msg213 When all that is finished the Auto AP dialog will re-appear and the checking transaction process starts all over again. There is a Related Modules command bar at the top of the checking transaction module. You may change the type of checking transaction you wish to perform at any time.
Msg214 The 'Action' buttons are the usual. You may clear the check if you need to start over. The often found calculator is there and when you are finished with the routine you may click the traffic light command bar button to close the routine.
Msg215 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you may click the 'Exit' command button to return to the tutorial.
Msg216
Msg217
Msg218
Msg219
Msg220 When Savings Projection first loads a graph is presented representing an account from the list of Savings accounts. Other information is presented also. A short wide list box shows account data for each projected contribution until the end of the projection for the account. A summary is displayed and several controls are visible too.
Msg221 The first controls to be explained are some of the command bar buttons. Notice that they are not arranged into groups like the main modules. The command bar at the top of this module window only has one row of labels since they are not easily confused as to their function. Next notice the list box that contains a list of Savings accounts as maintained in CEW.
Msg222 A graph may have appeared when the module loaded. The graph represents projected end of year balances for the first (or active) account in the Savings accounts list box. If no graph was drawn then either there was not enough data to graph or the list box was empty.
Msg223 If a graph did not appear when Savings Projection loaded - and even if it did - enter a value of 10000 into the 'Starting Balance' text box above. Enter 9 into the 'Ann. Int. %' text box. Now enter 2400 into the Ann. Cont.' text box. When this data is entered click the 'Show' command bar button and you will see a new graph appear. You may then study or print or copy the graph.
Msg224 If you would like a hard copy of the graph; summary or annual breakdown of the projection - you may click any or all of the 'Print Options' check boxes. Click the 'Print' command bar button and print the requested data to your printer. If you want to copy the graph to another program you may click 'Copy' to place a copy of the graph to the Windows clipboard.
Msg225 For brief help on using this module click the 'Help' command bar button. A brief message will be displayed. To go back to the 'Display Savings' module click the stop light or click the 'View' command button and the projection module will remain loaded.
Msg226 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you may click the 'Exit' command bar button to return to the tutorial.
Msg227
Msg228
Msg229
Msg230
Msg231
Msg232
Msg233
Msg234
Msg235
Msg236
Msg237
Msg238
Msg239
Msg240 The Reconcile routine in CEW is nothing less than great. Any thing that makes balancing your checkbook easy has to be great - maybe even amazing. There is really nothing to it!
Msg241 The Reconcile module contains a large list box containing your checking records and three command buttons. The procedure consists of finding all checks; deposits; ATM; BSP; and debit card transactions that appear on your monthly bank statement. As you find them you should click on the like transaction in the CEW reconciliation list box.
Msg242 To make matters easier you should check the items off your bank statement as you find them. Be sure to find them all and especially be sure to click off the deposits too. When you have found all these transactions you must click on the command button labeled 'Reconcile.' It can be found in the lower right corner of the reconciliation module.
Msg243 When you click the Reconcile button a text box will appear. Notice that the box in the lower left corner (that you can now see) also changes. This is a 'Prompt' box that helps you do things correctly. The prompt box tells you to enter all charges to your account into the text box. These charges usually consist of the monthly fee if any and/or check purchases.
Msg244 There may be others charges also. Be sure to add them all. Enter the TOTAL of all charges into the text box and use the calculator if it is convenient. You will find it on the main module 'Command Bar.' When the amount is entered into the text box press the 'Enter Amt' command button. The amount will be saved and a new prompt will appear.
Msg245 The new prompt will ask for the total for all credits to your account. These credits may be for anything except deposits. Add them all up if there is more than one and enter the TOTAL into the text box. Click the 'Enter Amt' command button once again. Again the amount will be saved. The text boxes will again clear and another prompt appear.
Msg246 This prompt will ask for CURRENT account balance as entered on your bank statement. Enter the amount into the text box and click the 'Enter Amt' command button one last time.
Msg247 From here CEW will calculate the new balance. If there is a difference you will be advised that there is a difference and the amount will be displayed. Now CEW wants to print a report. There will be a series of dialog boxes presented and you must make some YES or NO choices in. If you want to print a report you may.
Msg248 What if you want to print a report and you can't because your printer is down? You can postpone the report if you answer the forthcoming dialogs properly. You should answer NO to the first dialog and cancel on the second dialog. After the questions about the report you are finished with reconciliation.
Msg249 If there is a balance disparity after reconciliation you may investigate further after the dialogs. POSSIBLE DISPARITIES; 1.) Did you enter all the outstanding checks into CEW before reconciliation? 2.) Did you find all the transactions on the bank statement in the check register and click them all off?
Msg250 3.) Did you enter all the prompted for amounts correctly? 4.) Did you miss a check or deposit in a prior month and didn't notice until now? 5.) Were all the checks and deposits entered into CEW correctly? Any of these things could go wrong. Hopefully none of them will.
Msg251 'Play' with this module as you wish or until you become familiar with its capabilities. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you may click the 'Exit' command button for this module to return to the tutorial.
Msg252
Msg253
Msg254
Msg255
Msg256
Msg257
Msg258
Msg259
Msg260 This is the 'Checking Account Setup' module. If you run your monitor at one of the lower resolutions you may have to move the forthcoming dialog boxes in order to read the tutorial messages. It may be easier to read all the tutorial messages and then experiment with the setup routine.
Msg261 Before you can write checks you MUST run this routine. I refer to writing checks often in this tutorial. Writing checks refers to the act of entering checking transactions into CEW - including the act of printing checks with CEW.
Msg262 This also includes paying bills with the 'Pay Bills' routine if you use it. Checking setup is vital to CEW. There are several configuration parameters that are set during the course of checking setup. CEW is helpless to do its job correctly unless you tell it how you want the job done.
Msg263 Fortunately the chore isn't too difficult. When the module loads the cursor will be in the 'Balance' text box. You should enter the current checking account balance only if you have already entered all the outstanding checks from your checkbook.
Msg264 If this is the first time you have setup the checking account - 'Balance' will be empty. If you have already entered the outstanding checks into CEW then enter your current checking account balance. Press tab to go to the next text box and see the first dialog.
Msg265 The next several boxes are filled in by answering questions from dialog boxes. The first question asks if you have two check numbering systems (and two types of checks) for your checking account. Answer accordingly. You can change your mind at a later date.
Msg266 If you answered NO to the first question (one check type) the next question will ask which kind of check you are using. Answer YES or NO as it applies. CEW will then ask you a question about the physical size of the check(s). Another YES or NO answer is required.
Msg267 If you answer YES to the first question then different questions ask about the size and margins of the checks. Read carefully so you may answer correctly. Be aware that you MUST display your printer checks the proper size. If they are large then display the large image for printer checks.
Msg268 The next text box will ask if you want CEW to keep track of your check numbers. You should allow this but - you may choose not to allow it if you wish. I suggest that you let CEW do the work. Answer the question and see yet another dialog.
Msg269 The next decision is whether or not to print check numbers on your checks if you print some or all of your checks. The option is decided when (and if) you order printer checks. If you ordered printer checks pre-numbered then you won't want CEW to print them again - select NO.
Msg270 The last dialog now appears. If you intend to use window envelopes you may select YES to print the payee address on the check. This allows you to stuff the envelope with the address showing in the window. This will help speed the bill paying process.
Msg271 After the last dialog is answered the cursor will do one of three possible things. If you use printer checks (or printer AND checkbook checks) the cursor will appear in the 'Printer' text box. You should enter the check number for the next printer check you will use.
Msg272 If you are going to use checkbook checks the cursor will appear in the 'Portable' text box and you should enter the starting check number of those checks. If you track your own check numbers (No appears in 'Track No.s') then the 'Save' command button will highlight.
Msg273 Highlighting informs you that you may press the 'Enter' keyboard key to activate a command button. You should enter the check numbers as they are prompted for (if they are) and then click the 'Save' command button to save your setup.
Msg274 If you are trying to change your setup and get confused or make a mistake you may click the 'Restore' command button and the last saved setup will be restored for you. This action may save a little work or remind you of the last setup if you got confused.
Msg275 'Play' with this module as you wish or until you become familiar with its function. If you like you may click the 'Close' command button to make this help window disappear. When you are done experimenting you may click the 'Exit' command button to return to the tutorial.
Msg276
Msg277
Msg278
Msg279
Msg280 The 'Create Check Form' module is one of the most versatile and desirable features of CEW. In this module you may format the printer output for printing checks and design the on screen check images used in the check writing functions of CEW. You may also use this routine to redesign the default image for aesthetic reasons if you do not print checks.
Msg281 Some money mangers ask you to buy their expensive proprietary check forms to use with their programs. I allow you to use virtually any printer check with CEW. You may do this by designing an output format for the checks you buy. The following discussion assumes that you have already received the printer checks that you are going to use.
Msg282 The following discussion also assumes that you will use a standard check size of either 8.5 inches wide by 3.5 inches long; or 6 inches wide by 2 13/16 inches long. This discussion is for fan fold type checks used in dot matrix printers (DMP). A discussion of laser (sheet) type checks will follow.
Msg283 To print fan-fold checks you must be familiar with the Windows Print Manger setup routine. Both CEW 'Help' and the 'User Guide' covers the subject in detail. To brush up on this simple procedure you may select 'File' from the CEW main menu then select 'Printer Setup.' Press F1 while still holding down the left mouse button (or while 'Printer Setup' is highlighted).
Msg284 When the check design module loads you will see a preliminary check form image displayed in the window. There will be several option buttons; command buttons and information boxes below that. The first thing you must do is tell CEW what kind of checks (the type of printer actually) you are using. By the way - it is perfectly OK to use sheet checks in DMPs if the DMP will feed them.
Msg285 Since the current discussion is about DMPs you should make sure that the 'Laser Check' check box at the bottom center of the module is NOT checked. Click in the small square to toggle it off if it IS checked.
Msg286 Now you must select the proper check size for the printer check you are going to use. The dimensions are listed by the option boxes representing both supported sizes. Click on the proper size option. The next order of business is to load your checks into the printer. I recommend that for the purpose of check design you use plain paper instead of your checks.
Msg287 There is no need to waste good checks and the money spent on them. Load plain paper instead and follow these instructions carefully. The most important part of this routine is loading the checks (or paper) the same way every time. If you have a 'Form Load' button on your printer then the battle is won.
Msg288 If you don't have a form load button then you should (in my experience) load the form so that the top edge of the first check (or paper) is even with the top of the printer ribbon. Always - AL-ways - ALWAYS use the normal left margin on your printer. This is the location where 8.5 X 11 inch paper is normally loaded.
Msg289 Next to discuss is the two rather large information boxes at the lower left. These boxes will display the location of the check fields that the mouse cursor is over. To demonstrate this - place the mouse cursor over any of the gray boxes on the check image. Notice that the information boxes display different information for each gray check field.
Msg290 The top information box displays the current field location in row and column format. The font used is a standard system font that prints at ten characters per inch and six lines per inch. An 8.5 X 3.5 inch check is 85 characters wide and 21 rows (lines) long. A small check is 60 characters wide and 16 rows long. This information may aid you in check design.
Msg291 The bottom information box displays the location (in inches) that the current field should print to - from the upper left corner of the printer check. This makes it possible to use a ruler to measure the location of the check fields on the real check and place the fields (on-screen) in the precise position that they need to print to.
Msg292 To place the fields using either method you may click on the field with the left mouse button and while holding the button down 'drag' the field to its approximate new location then release the mouse button. Check the information box to see if you are close to the desired location and adjust if necessary.
Msg293 If the cursor is over any other field or over any part of the original location of the field being moved when you release the mouse button - the field will jump to the upper left corner of the check. This HELPS prevent stacking fields on one another and HELPS prevent them from printing illegibly (on top of each other).
Msg294 Drag all the fields to positions that look like they will print correctly. If you measured the field locations; drag the fields to the approximate locations that you measured them to. It may be just as easy to 'eyeball' the locations if you have a good 'eye' for that sort of thing.
Msg295 When all the fields are located you should click the 'Save' command button then click the 'Print' command button to print a test check. Remove the first form (sheet of paper) from your printer. Superimpose the paper over a real check and align the top and left edges of the check while holding them up to the light.
Msg296 You should be able to see through the paper to the real check and see if the checks are going to print properly. If you use real checks you can readily see the field placement. If they didn't print quite right then you can make subtle changes to the field placements and print again. Remember to save first! Continue until you are satisfied with the output.
Msg297 Laser checks (or any sheet style check that you use in any type of printer) is setup in much the same manner. If you use sheet checks (three to a page ONLY) you should set form size (in the Windows Print Manger for your printer) to 8.5 inches by 11 inches. Be sure to select 'Laser Checks' in the check box below and do all the rest of the setup in the same fashion as in DMP setup.
Msg298 You may use either check size (8.5 X 3.5 inches or 6 X 2 13/16 inches) with both check types (DMP or laser). CEW will allow for the 2.5 inch left margin in the smaller size so don't allow for the margin when setting up either type of small check (DMP or laser).
Msg299 An added benefit to this routine is that once the routine is finished you will never have to 'jockey' your check forms around when you load them. Just hit the form load button and print the checks. I know a lot of people that use some of the other programs and they have to jockey the first two or three checks before they are finally printing correctly.
Msg300 To summarize this module - you can print any of four types/sizes of checks; you can eliminate form jockeying; you can shop around for the best deal on checks; and you can make it all work in about 3 to 5 minutes. Not bad!
